package com.pls.dao;


import java.sql.SQLException;
import java.util.List;

import com.pls.domain.Employee;
import com.pls.domain.EmployeeWorkstation;
import com.pls.domain.Seat;


public interface SeatDAO {
	
	
	public boolean insertNewEmployeeSeat(EmployeeWorkstation employeeWorkstation);

	public boolean updateEmployeeSeat(Employee employee, String newSeatCode);
	
	public boolean deleteEmployeeSeat(Employee employee);
	
	public List<EmployeeWorkstation>  getSeatPlanByFloor(String location, String floor)throws SQLException, Exception;

	public List<EmployeeWorkstation> getSeatPlanByQuadrant(String location, String quadrant)throws SQLException,Exception;
	
	public List<EmployeeWorkstation> getSeatCodesByFloor(String location, String floor) throws SQLException, Exception;
	
	}

